SCM - Adithya-Venkat - 2016-09-02 - 26998 - Transaction for PO Download File in ECC (Jeff by 09-09-2016) #hold

SPECIFICATIONS

26998 - Spec - Transaction in ECC for PO Download


Purpose

Create a Transaction in ECC for suppliers to use the PO Download in ECC.

Admin Info

Purpose
 Transaction in ECC for PO Download file
Requested By
 Jeffrey Mau
Spec Created By
 Adithya
Spec Created Date
 09/08/2016
Spec QA by
 Adithya
Objects
 ZNEC_FM_PO_DOWNLOAD
Document Status
 WIP

Estimates

Sl.No
 Activity
 Estimation in Hours
1
 Research
2
 Documentation
 08
3
 Development/ Config
 12
4
 Unit test in DEV
 06
5
 Unit test in QUA
6
 Other activity

TOTAL
 24

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

Documents

[Attach any document(s) received for the requirement(s)]

Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any





Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]
As SNC is replaced by CHR, the PO Download shall be take from ECC by the suppliers.
Create a transaction in ECC for suppliers to use the PO Download functionality which is there in the SNC Web Screen to Download the PO File.
Below is the screen which shows the PO Download Button in the SNC Web Screen.
PODOWNLOAD_1.JPG

The New Transaction which is created in ECC shall have the PO Number as input.

In Scope:
[List the activities to be included in scope]
The file would be generated for One PO at once.
The transaction shall work just same it works in SNC Web Screen.

Out of Scope:

[Out of scope activities]
Multiple PO Input.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]
A Function Module "ZNEC_FM_PO_DOWNLOAD" is created in ECC so that this FM is called when the PO Download button is hit from SNC Web Screen and the data is extracted in the form of a excel sheet.

Create a Program and assign a Transaction for it. The Program shall use the same FM "ZNEC_FM_PO_DOWNLOAD" to get the data and generate a excel file which shall be able to save the file in the local drive.
Program shall have PO number as Input.
The Name of the File is currently "myPo" the Name shall be same ?

Security:
In SNC, as we login with respect to the vendor system only shows up the POs which are created for the same vendor in PO Overview screen Screen and hence PO Download can be generated for only that vendor POs.
But when the same FM is used in ECC to fetch the data there may be a chance of supplier users to access other vendor Pos. Here we may use the same table "ZMM_INB_VAL" for authorization which is used to create the Inbound Delivery.
The Users which are assigned to the vendor shall only be able to generate a file for the POs which are created for assigned Vendor.

Here is the table which is having the data form NEP:
PODOWNLOAD_2.JPG

Test Plan

[List test scenarios/cases to be executed here]
Test ID
 Test Scenario
 Expected Results
PODWNLD1
 Execute the transaction with Po as input for the same vendor for which the user id is assigned to
 The File shall be generated for the PO.
PODWNLD2
 Execute the transaction with Po as input, PO created for the different vendor of which is assigned in the table
 A message shall be shown that "You are not authorized to generate file for this PO"
PODWNLD3
 Execute the transaction with the SNC Pos as input
PODWNLD4
 Validate and Check the data for the PO in PO Download file for NB, NB TAB & Z3NB POs
 The Data in the file shall be correct when compared with the file generated form SNC Web

Solution Details

[Provide complete technical details for configuration or programming here]


Issues

[List Issues / Bugs identified in configuration or development]